create table jms_dm.dm_download_sign_abnomal_detail_dt (
                                                           agent_code varchar(30) comment '代理区code',
                                                           site_code varchar(30) comment '网点code',
                                                           billcode varchar(30) comment '单号',
                                                           agent_name varchar(30) comment '代理区name',
                                                           store_name varchar(120) comment '驿站nmae',
                                                           store_code varchar(30) comment '驿站code',
                                                           site_name varchar(80) comment '网点name',
                                                           scan_time_in datetime comment '入库扫描时间',
                                                           scan_time_out datetime comment '出库扫描时间',
                                                           scan_time_take datetime comment '快件取出扫描时间',
                                                           signed_time datetime comment '签收扫描时间',
                                                           is_work_order tinyint comment '是否客诉1是',
                                                           is_flas_sign tinyint comment '是否虚假签收1是',
                                                           apply_type_code int comment '退转类型4退件5转寄',
                                                           detail_type int comment '导数类型 1有入库没有取出直接签收；2签收前有出库；3签收扫描后有入库或出库扫描;4 签收删除',
                                                           is_sign_del int comment '是否签收删除 1是',
                                                           sign_delete_time datetime comment'签收删除时间',
                                                           date_time date comment'查询日期'
) ENGINE=OLAP
DUPLICATE KEY(agent_code,site_code)
COMMENT "下载中心_虚假签收明细"
PARTITION BY RANGE(date_time)
(START ("2023-10-01") END ("2023-10-15") EVERY (INTERVAL 1 day))
DISTRIBUTED BY HASH(detail_type) BUCKETS 2
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-14",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "2",
"in_memory" = "false",
"storage_format" = "V2"
);
